
-- ----------------------------
--  Records of tArrearage
-- ----------------------------
BEGIN;
INSERT INTO "tArrearage" (
    "aOrderNo" ,
    "aCoNo" ,
    "aArreaMoney" ,
    "aBusinessmanNo" ,
    "aBusinessman" ,
    "aArreaReason" ,
    "aCreateUserNo",
    "aCreateUserName",
    "aCreateTime" ,
    "aRemark"
)
 VALUES (2016010100001, 'commodity00001', 5000.0, 'JSJ001', '佳乐家001', '购买了金锣火腿肠', 'gcx', 'gcx', '2016-11-08 14:41:03', 'remark');
COMMIT;

-- ----------------------------
--  Records of tCommodityCategory
-- ----------------------------
BEGIN;
INSERT INTO "tCommodityCategory" (
    "caFirstType" ,
    "caSecondType" ,
    "caThirdType" ,
    "caFourthType" ,
    "caFifthType" ,
    "caWarehouseNo" ,
    "caWarehouse" ,
    "caCreateUserNo" ,
    "caCreateTime" ,
    "caRemark"
) 
VALUES ('食品', '金锣', '金锣王10*50g', null, null, 'CK001', '仓库001', 'gcx', '2016-11-08 10:35:58', '');

INSERT INTO "tCommodityCategory" (
    "caFirstType" ,
    "caSecondType" ,
    "caThirdType" ,
    "caFourthType" ,
    "caFifthType" ,
    "caWarehouseNo" ,
    "caWarehouse" ,
    "caCreateUserNo" ,
    "caCreateTime" ,
    "caRemark"
) 
VALUES ('食品', '旺旺', '旺旺雪饼10*15g', null, null, 'CK001', '仓库001', 'gcx', '2016-11-08 14:41:03', null);
COMMIT;

-- ----------------------------
--  Records of tCommodityInfo
-- ----------------------------
BEGIN;
INSERT INTO "tCommodityInfo" (
	 "cCoNo" ,
	 "cName" ,
	 "cCategory" ,
	 "cUnit" ,
	 "cUnitConversion" ,
     "cPriceType",
	 "cPrice" ,
	 "cCreateUserNo" ,
	 "cCreateTime" ,
	 "cRemark" 
) 
VALUES ('commodity00001', '金锣王10*50g', '食品,金锣,金锣王10*50g', '箱,包', '*50,*1', '标准价', '450.00,9.00', 'gcx', '', '');

INSERT INTO "tCommodityInfo" (
	 "cCoNo" ,
	 "cName" ,
	 "cCategory" ,
	 "cUnit" ,
	 "cUnitConversion" ,
     "cPriceType",
	 "cPrice" ,
	 "cCreateUserNo" ,
	 "cCreateTime" ,
	 "cRemark" 
) 
VALUES ('commodity00002', '旺旺雪饼10*15g', '食品,旺旺,旺旺雪饼10*15g', '箱,袋', '*20,*1', '标准价', '100.00,5.00', 'gcx', '2016-11-08 14:17:41', null);
COMMIT;

-- ----------------------------
--  Records of tGatheringDay
-- ----------------------------
BEGIN;
INSERT INTO "tGatheringDay" (
    "gOrderNo" ,
    "gOrderType" ,
    "gCoNo" ,
    "gBusinessmanNo" ,
    "gBusinessman" ,
    "gGatheringTime" ,
    "gGatheringReason" ,
    "gCreateUserNo" ,
    "gCreateTime" ,
    "gRemark" 
) 
VALUES (2016010100001, 1, 'commodity00001', 'JSJ001', '佳乐家001', '2015-02-02 12:00:02', '收款', 'gcx', '', '');
COMMIT;

-- ----------------------------
--  Records of tInventoryInfo
-- ----------------------------
BEGIN;
INSERT INTO "tInventoryInfo" (
    "iCoNo" ,
    "iUnit" ,
    "iInventoryCount" ,
    "iCreateUserNo" ,
    "iCreateTime" ,
    "iRemark" 
) 
VALUES ('commodity00001', '箱,包', '12,30', 'gcx', '', '');

INSERT INTO "tInventoryInfo" (
    "iCoNo" ,
    "iUnit" ,
    "iInventoryCount" ,
    "iCreateUserNo" ,
    "iCreateTime" ,
    "iRemark" 
) 
VALUES ('commodity00002', '箱,袋', '20,15', 'gcx', '2016-11-08 14:39:59', null);
COMMIT;

-- ----------------------------
--  Records of tOrderInfo
-- ----------------------------
BEGIN;
INSERT INTO "tOrderInfo" (
    "orOrderNo" ,
    "orTotalPrice" ,
    "orWarehouseNo" ,
    "orSalesmanNo" ,
    "orSalesman" ,
    "orBusinessmanNo" ,
    "orBusinessman" ,
    "orSaleType" ,
    "orSettlementType" ,
    "orState" ,
    "orCreateTime" ,
    "orRemark" 
) 
VALUES (2016010100001, 1315.0, 'CK001', 'gcx', 'gcx', 'JSJ001', '佳乐家001', 0, 0, 0, '', '');
COMMIT;

-- ----------------------------
--  Records of tReturnInfo
-- ----------------------------
BEGIN;
INSERT INTO "tReturnInfo" (
    "rOrderNo" ,
    "rNewOrderNo" ,
    "tType" ,
    "rBusinessmanNo" ,
    "rBusinessman" ,
    "rCreateUserNo" ,
    "rCreateTime" ,
    "rRemark" 
) 
VALUES (1, 1, 1, 1, 1, 1, 1, '');
COMMIT;

-- ----------------------------
--  Records of tSaleInfo
-- ----------------------------
BEGIN;
INSERT INTO "tSaleInfo" (
    "sOrderNo" ,
    "sCoNo" ,
    "sName" ,
    "sCategory" ,
    "sUnit" ,
    "sPrice" ,
    "sCount" ,
    "sWarehouseNo" ,
    "sWarehouseName" ,
    "sSalesmanNo" ,
    "sSalesman" ,
    "sBusinessmanNo" ,
    "sBusinessman" ,
    "sSaleType" ,
    "sSettlementType" ,
    "sPromotionType" ,
    "sCreateTime" ,
    "sState" ,
    "sRemark" 
) 
VALUES ('2016010100001', 'commodity00001', '金锣王10*50g', '食品,金锣,金锣王10*50', '箱,包', '450.00,9.00', '2,10', 'CK001 ', '仓库001', 'gcx', '测试业务员01', 'JSJ001', '佳乐家001', 0, 0, 0, '2016-11-08 10:05:28', 1, '备注信息01_00');

INSERT INTO "tSaleInfo" (
    "sOrderNo" ,
    "sCoNo" ,
    "sName" ,
    "sCategory" ,
    "sUnit" ,
    "sPrice" ,
    "sCount" ,
    "sWarehouseNo" ,
    "sWarehouseName" ,
    "sSalesmanNo" ,
    "sSalesman" ,
    "sBusinessmanNo" ,
    "sBusinessman" ,
    "sSaleType" ,
    "sSettlementType" ,
    "sPromotionType" ,
    "sCreateTime" ,
    "sState" ,
    "sRemark" 
) 
VALUES ('2016010100001', 'commodity00002', '旺旺雪饼10*15g', '食品,旺旺,旺旺雪饼10*15g', '箱,袋', '100.00,5.00', '3,5', 'CK001 ', '仓库001', 'gcx', '测试业务员01', 'JLJ001', '佳乐家001', 0, 0, 0, '2016-11-08 10:05:28', 1, '备注信息01_01');
COMMIT;

-- ----------------------------
--  Records of tUserInfo
-- ----------------------------
BEGIN;
INSERT INTO "tUserInfo" (
    "uUserNo" ,
    "uUserName" ,
    "uType" ,
    "uPhone" ,
    "uAddr" ,
    "uWarehouseNo" ,
    "uCreateTime",
    "uRemark" 
) 
VALUES ('gcx', 'gcx', 1, '13866668888', '', 'CK001', '2016-08-08 08:08:08', '');

INSERT INTO "tUserInfo" (
    "uUserNo" ,
    "uUserName" ,
    "uType" ,
    "uPhone" ,
    "uAddr" ,
    "uWarehouseNo" ,
    "uCreateTime",
    "uRemark" 
) 
VALUES ('JSJ001', '佳乐家001', 2, null, null, null, '2016-11-08 14:34:38', null);
COMMIT;


